﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_USR_FAVORITE_SEARCH_Insert')
	BEGIN
		DROP Procedure usp_UPDMS_USR_FAVORITE_SEARCH_Insert
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_USR_FAVORITE_SEARCH_Insert
**	Desc : 검색결과 즐겨찾기를 저장한다.
**	Test Exec Query : Exec usp_UPDMS_USR_FAVORITE_SEARCH_Insert
**	Called by : Usr_Dac_UPDMS_USR_FAVORITE_SEARCH.cs
**	Program ID : Usr1011m
**	Auth : 송시명
**	Date : 2014-08-19
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_USR_FAVORITE_SEARCH_Insert]
@Seq int,
@User_Id nvarchar(20),
@Pgm_Id nvarchar(20),
@Title nvarchar(1000),
@Search_Condition nvarchar(max),
@Create_User nvarchar(20),
@Create_Dt datetime,
@Update_User nvarchar(20),
@Update_Dt datetime
AS
SET NOCOUNT OFF

INSERT INTO UPDMS_USR_FAVORITE_SEARCH (
       User_Id,
       Pgm_Id,
       Title,
       Search_Condition,
       Create_User,
       Create_Dt,
       Update_User,
       Update_Dt
)
VALUES (
       @User_Id,
       @Pgm_Id,
       @Title,
       @Search_Condition,
       @Create_User,
       GETDATE(),
       @Update_User,
       GETDATE()
)

GO